COVID-19 in Italy. Visuals

(alternatively, see results and code together here)

 

Data source: this GitHubi page

Authors and sources mentioned: Editore/Autore del dataset: Dipartimento della Protezione Civile. Categoria ISO 19115: Salute. Dati forniti dal Ministero della Salute.

Regional data files (Dati per Regione):
  • Struttura file giornaliero: dpc-covid19-ita-regioni-yyyymmdd.csv (dpc-covid19-ita-regioni-20200224.csv)
  • File complessivo: dpc-covid19-ita-regioni.csv
  • File ultimi dati (latest): dpc-covid19-ita-regioni-latest.csv

 

Out[45]:

Currently data as of date: 2020-10-29T17:00:00

 

What's in the original dataframe?

Out[46]:

All column names: ['data', 'stato', 'codice_regione', 'denominazione_regione', 'lat', 'long', 'ricoverati_con_sintomi', 'terapia_intensiva', 'totale_ospedalizzati', 'isolamento_domiciliare', 'totale_positivi', 'variazione_totale_positivi', 'nuovi_positivi', 'dimessi_guariti', 'deceduti', 'casi_da_sospetto_diagnostico', 'casi_da_screening', 'totale_casi', 'tamponi', 'casi_testati', 'note']

Out[47]:
data stato codice_regione denominazione_regione lat long ricoverati_con_sintomi terapia_intensiva totale_ospedalizzati isolamento_domiciliare ... variazione_totale_positivi nuovi_positivi dimessi_guariti deceduti casi_da_sospetto_diagnostico casi_da_screening totale_casi tamponi casi_testati note
5224 2020-10-29T17:00:00 ITA 19 Sicilia 38.115697 13.362357 839 115 954 11791 ... 557 789 6605 472 12621.0 7201.0 19822 669376 472930.0 NaN
5225 2020-10-29T17:00:00 ITA 9 Toscana 43.769231 11.255889 956 137 1093 22877 ... 1610 1966 13678 1310 31190.0 7768.0 38958 1056864 706557.0 NaN
5226 2020-10-29T17:00:00 ITA 10 Umbria 43.106758 12.388247 260 41 301 5270 ... 572 694 3277 119 2917.0 6050.0 8967 290964 169837.0 NaN
5227 2020-10-29T17:00:00 ITA 2 Valle d'Aosta 45.737503 7.320149 120 7 127 1457 ... 154 178 1235 162 2635.0 346.0 2981 40095 25235.0 NaN
5228 2020-10-29T17:00:00 ITA 5 Veneto 45.434905 12.338452 759 97 856 22770 ... 2026 2109 25247 2371 24522.0 26722.0 51244 2288598 890507.0 NaN

5 rows × 21 columns

 

Variable names to English and their explanation

  • HospWithSymptoms : Currently hospitalized patients with symptoms
  • IC : Intensive care
  • HospTotal: Total number of currently hospitalized patients
  • AtHome : Currently at home confinement
  • CurrentlyPositive : Total amount of current positive cases (Hospitalised patients + Home confinement)
  • NewPositives : New amount of positive cases (Actual total amount of current positive cases - total amount of current positive cases of the previous day)
  • TotalCases : Total amount of positive cases
  • NoOfTests : Tests performed
Out[48]:
Date Region Lat Long HospWithSymptoms IC HospTotal AtHome CurrentlyPositive VariationOfPositives NewPositives Recovered Deaths Diagnostico Screening TotalCases NoOfTests casi_testati note Pop
Date
2020-10-25 2020-10-25 Veneto 45.434905 12.338452 585 71 656 16316 16972 1351 1468 25036 2329 24005.0 20332.0 44337 2238353 871568.0 NaN 4905854
2020-10-26 2020-10-26 Veneto 45.434905 12.338452 612 76 688 17359 18047 1075 1129 25087 2332 24066.0 21400.0 45466 2246098 874701.0 NaN 4905854
2020-10-27 2020-10-27 Veneto 45.434905 12.338452 664 83 747 18770 19517 1470 1526 25131 2344 24220.0 22772.0 46992 2259786 880224.0 NaN 4905854
2020-10-28 2020-10-28 Veneto 45.434905 12.338452 708 90 798 20802 21600 2083 2143 25180 2355 24377.0 24758.0 49135 2275869 886165.0 NaN 4905854
2020-10-29 2020-10-29 Veneto 45.434905 12.338452 759 97 856 22770 23626 2026 2109 25247 2371 24522.0 26722.0 51244 2288598 890507.0 NaN 4905854

 

daily numbers & moving averages (MA)

(double click and click on legend to select one or multiple regions in the graph)

 

All regions together